insert into pub_page_templet(pk_page_templet,appcode,clazz,code,creationtime,creator,dr,headcode,isdefault,metaid,modifiedtime,modifier,name,pagecode,parentid,pk_group,pk_org,resid,resmodule,templetdesc,ts)
values('0001ZZZZ3cefbdb1d8fb','60071051',null,'60071051_FileRole',null,'~',0,'head','Y',null,null,'~','文件权限配置','60071051_FileRole','root',null,null,'60071051_0001',null,null,'2022-02-20 13:34:57');
go

insert into pub_area(pk_area,areadesc,areastatus,areatype,clazz,code,creationtime,creator,dr,isunfold,metaid,metaname,metaspace,modifiedtime,modifier,name,pagination,position,relationcode,resid,templetid,ts)
values('0001ZZZZ20c7fa3e0549','文件权限配置查询模板',null,0,null,'search','2022-02-20 13:34:57','~',0,'Y','5f665521-9f88-4008-8a24-b8678bd39f94','附件权限管理','hrhi.filerole',null,'~','文件权限配置查询模板','false',1,null,'60071051_0002','0001ZZZZ3cefbdb1d8fb','2022-02-20 13:34:57');
go

insert into pub_area(pk_area,areadesc,areastatus,areatype,clazz,code,creationtime,creator,dr,isunfold,metaid,metaname,metaspace,modifiedtime,modifier,name,pagination,position,relationcode,resid,templetid,ts)
values('0001ZZZZ40ab3f5fff7e','文件权限配置',null,2,'nc.vo.hi.file.FileRoleVO','head','2022-02-20 13:34:57','~',0,'Y','5f665521-9f88-4008-8a24-b8678bd39f94','附件权限管理','hrhi.filerole',null,'~','文件权限配置','false',2,null,'60071051_0003','0001ZZZZ3cefbdb1d8fb','2022-02-20 13:34:57');
go


            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ58b553ca51a2','0001ZZZZ20c7fa3e0549','5f665521-9f88-4008-8a24-b8678bd39f94','pk_role',null,null,'~',204,'0001Z01000000003FR99,code=N','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','refer','业务角色',20,'uap.Role.role_name','pk_role','=@','等于@',6,'0e77b596-f7eb-46ca-b47d-272c4aa72149','','/common-ref/','角色','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ9ad637e9d926','0001ZZZZ20c7fa3e0549','5f665521-9f88-4008-8a24-b8678bd39f94','pk_filerole',null,null,'~',1,'','','','','','','','N',0,'N','N','N','N','N','Y','Y','Y','input','主键',50,NULL,'pk_filerole','=@','等于@',1,'58bedb7f-0a64-4648-a5bf-d7b088cfc7b3','','/common-ref/','-99','N','','refpk',1,'','2022-02-20 13:34:57','N','N',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ919d5460848c','0001ZZZZ20c7fa3e0549','5f665521-9f88-4008-8a24-b8678bd39f94','modifier',null,null,'~',204,'0001Z01000000001BVPB,code=N','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','refer','修改人',20,'uap.user.user_name','modifier','=@','等于@',9,'a9660025-d9db-45b8-b31c-1cd19577c974','','/common-ref/','用户','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZaccd598c8dcd','0001ZZZZ20c7fa3e0549','5f665521-9f88-4008-8a24-b8678bd39f94','modifiedtime',null,null,'~',34,'','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','datetimepicker','修改时间',19,NULL,'modifiedtime','=@','等于@',10,'dcf81f24-a17f-469e-8ed9-e005fac0a01e','','/common-ref/','-99','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ0e924a4ff883','0001ZZZZ20c7fa3e0549','5f665521-9f88-4008-8a24-b8678bd39f94','creator',null,null,'~',204,'0001Z01000000001BVPB,code=N','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','refer','创建人',20,'uap.user.user_name','creator','=@','等于@',7,'dabdb2ca-ad71-4fbb-b830-6acdcaa80943','','/common-ref/','用户','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ43cfbdddf3b2','0001ZZZZ20c7fa3e0549','5f665521-9f88-4008-8a24-b8678bd39f94','creationtime',null,null,'~',34,'','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','datetimepicker','创建时间',19,NULL,'creationtime','=@','等于@',8,'9b95e137-59e2-4b46-91cd-82de8a85238c','','/common-ref/','-99','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ4fe99b2a7013','0001ZZZZ20c7fa3e0549','5f665521-9f88-4008-8a24-b8678bd39f94','pk_filetype',null,null,'~',1,'','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','input','文件类别',50,NULL,'pk_filetype','=@','等于@',5,'7b095b35-697a-4a9e-9dc0-2e3550a81ab5','','/common-ref/','-99','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ914cb79393d3','0001ZZZZ20c7fa3e0549','5f665521-9f88-4008-8a24-b8678bd39f94','pk_org',null,null,'~',204,'','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','refer','组织',20,NULL,'pk_org','=@','等于@',3,'c77ea95c-0013-452e-af1e-c8217fe5c333','','/common-ref/','组织','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZff6195f78806','0001ZZZZ20c7fa3e0549','5f665521-9f88-4008-8a24-b8678bd39f94','pk_org_v',null,null,'~',204,'','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','refer','组织版本',20,NULL,'pk_org_v','=@','等于@',4,'945dcd58-250b-4cab-859e-2a95eab2d419','','/common-ref/','组织_版本信息','N','','refpk',1,'','2022-02-20 13:34:57','N','N',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ2ac14eb53b65','0001ZZZZ20c7fa3e0549','5f665521-9f88-4008-8a24-b8678bd39f94','pk_group',null,null,'~',204,'','','','','','','','N',0,'N','N','N','N','N','Y','Y','Y','refer','集团',20,NULL,'pk_group','=@','等于@',2,'51637407-a243-4bf9-893b-5824d8b966c4','','/common-ref/','组织_集团','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go



